www.gusucode.com > 网页游戏五子棋onWeb 2008asp网站源码程序 > 网页游戏五子棋onWeb 2008asp网站源码程序/five/getTableInfo.php
<?php include "./dbconnect.php"; $query = phpsql_query("select * from `room` where `ID` = '".$_GET[roomID]."'"); //$num = phpsql_num_rows($query); $ID = phpsql_result($query, 0, ID); $player1_name = phpsql_result($query, 0, player1_name); $player2_name = phpsql_result($query, 0, player2_name); $player1_time = phpsql_result($query, 0, player1_time); $player2_time = phpsql_result($query, 0, player2_time); $player1_win = phpsql_result($query, 0, player1_win); $player2_win = phpsql_result($query, 0, player2_win); $player1_show = phpsql_result($query, 0, player1_show); $player2_show = phpsql_result($query, 0, player2_show); $system_time = phpsql_result($query, 0, system_time); $flag = phpsql_result($query, 0, flag); $chess = phpsql_result($query, 0, chess); $f = 1; if($player1_name && $ori_time - $player1_time > 30) { phpsql_query("update `room` set `flag` = '',`chess` = '',`player1_name` = '',`player1_time` = '0',`player1_win` = '0',`player2_win` = '0',`player1_show` = '' where `ID` = '".$_GET[roomID]."'"); $f = 0; } if($player2_name && $ori_time - $player2_time > 30) { phpsql_query("update `room` set `flag` = '',`chess` = '',`player2_name` = '',`player2_time` = '0',`player1_win` = '0',`player2_win` = '0',`player2_show` = '' where `ID` = '".$_GET[roomID]."'"); $f = 0; } if($_GET[player_name] == $player1_name) phpsql_query("update `room` set `player1_name` = '".$_GET[player_name]."',`player1_time` = '".$ori_time."',`system_time` = '".$ori_time."' where `ID` = '".$_GET[roomID]."'"); if($_GET[player_name] == $player2_name) phpsql_query("update `room` set `player2_name` = '".$_GET[player_name]."',`player2_time` = '".$ori_time."',`system_time` = '".$ori_time."' where `ID` = '".$_GET[roomID]."'"); if($_GET[player_name] == $player1_name && $chess == "" && $player1_name && $player2_name && $player1_show && $player2_show) { for($chess = '', $i = 0;$i < 15 * 15;$i ++) $chess .= "blank,"; phpsql_query("update `room` set `flag` = '".(($flag == 'player1' || $flag == '1')?'player2':'player1')."',`chess` = '".$chess."' where `ID` = '".$_GET[roomID]."'"); } //判断胜负 if($player1_show && $player2_show){ $e_chess = explode(",", $chess); for($i = 0;$i < 15 * 15;$i ++) { if($e_chess[$i] == "blackChess") { if($i % 15 == 0) $blackChess_count_row = 0; $blackChess_count_row ++; $blackChess_count_col = 0; for($j = $i;$j < 15 * 15;$j += 15) { if($e_chess[$j] == "blackChess") $blackChess_count_col ++; else break; } $blackChess_count_right = 0; for($j = $i;$j < 15 * 15;$j += 14) { if($e_chess[$j] == "blackChess") $blackChess_count_right ++; else break; } $blackChess_count_left = 0; for($j = $i;$j < 15 * 15;$j += 16) { if($e_chess[$j] == "blackChess") $blackChess_count_left ++; else break; } }else $blackChess_count_row = 0; if($e_chess[$i] == "whiteChess") { if($i % 15 == 0) $whiteChess_count_row = 0; $whiteChess_count_row ++; $whiteChess_count_col = 0; for($j = $i;$j < 15 * 15;$j += 15) { if($e_chess[$j] == "whiteChess") $whiteChess_count_col ++; else break; } $whiteChess_count_right = 0; for($j = $i;$j < 15 * 15;$j += 14) { if($e_chess[$j] == "whiteChess") $whiteChess_count_right ++; else break; } $whiteChess_count_left = 0; for($j = $i;$j < 15 * 15;$j += 16) { if($e_chess[$j] == "whiteChess") $whiteChess_count_left ++; else break; } }else $whiteChess_count_row = 0; if($blackChess_count_row == 5 || $blackChess_count_col == 5|| $blackChess_count_left == 5|| $blackChess_count_right == 5) { $player1_win ++; phpsql_query("update `room` set `flag` = '1',`player1_win` = '".$player1_win."',`player1_show` = '',`player2_show` = '' where `ID` = '".$_GET[roomID]."'"); $f = 0; break; } if($whiteChess_count_row == 5 || $whiteChess_count_col == 5 || $whiteChess_count_left == 5|| $whiteChess_count_right == 5) { $player2_win ++; phpsql_query("update `room` set `flag` = '2',`player2_win` = '".$player2_win."',`player1_show` = '',`player2_show` = '' where `ID` = '".$_GET[roomID]."'"); $f = 0; break; } } //判断胜负-END } $roomInfo = "0|".$player1_name."|".$player2_name."|".$flag."|".$chess."|".$player1_win."|".$player2_win."|".$player1_show."|".$player2_show."|;"; echo $roomInfo; ?>